Autonomous Query-driven Index Tuning
نویسندگان
چکیده
Index tuning as part of database tuning is the task of selecting and creating indexes with the goal of reducing query processing times. However, in dynamic environments with various ad-hoc queries it is difficult to identify potentially useful indexes in advance. In this paper, we investigate an approach addressing this problem by deciding about index creation automatically at runtime in order to speed up processing of subsequent queries. We present a cost model taking into account the benefits of indexes for an evolving query workload and discuss strategies for choosing indexes to be created in a space-limited environment.
منابع مشابه
QUIET: Continuous Query-driven Index Tuning
Index tuning as part of database tuning is the task of selecting and creating indexes with the goal of reducing query processing times. However, in dynamic environments with various ad-hoc queries it is difficult to identify potential useful indexes in advance. In this demonstration, we present our tool QUIET addressing this problem. This tool “intercepts” queries and – based on a cost model as...
متن کاملzTuned: Automated SQL Tuning through Trial and (Sometimes) Error
SQL tuning—the attempt to improve a poorly-performing execution plan produced by the database query optimizer—is a critical aspect of database performance tuning. Ironically, as commercial databases strive to improve on the manageability front, SQL tuning is becoming more of a black art. It requires a high level of expertise in areas like (i) query optimization, run-time execution of query plan...
متن کاملSelf-Tuning Storage and Indexing for Native XML DBMSs
Today, database management systems (DBMSs) are ubiquitous and they often build the backbone of highly complex IT systems. Their flexibility, scalability, and configurability make them useful for a wide range of applications. From handheld devices to worldwide online systems, DBMSs operate reliably and are available 24/7. However, changing conditions such as (periodic) workload shifts, growing d...
متن کاملAutomatic Physical Design Tuning based on Hypothetical Plans
It is well-known that fine tuning in database physical design is an important strategy for speeding up data access. In this paper, we introduce a new approach, denoted HypoPlans, to make relational database systems able to execute self-tuning actions, based on the notion of Hypothetical Query Execution Plans. HypoPlans is non-intrusive and completely autonomous. In this sense, it is DBMS-indepe...
متن کاملIntegrated Project Member of the FET Proactive Initiative Complex Systems DELIS-TR-0295 Bookmark-driven Query Routing in Peer-to-Peer Web Search
We consider the problem of collaborative Web search and query routing strategies in a peer-to-peer (P2P) environment. In our architecture every peer has a full-fledged search engine with a (thematically focused) crawler and a local index whose contents may be tailored to the user’s specific interest profile. Peers are autonomous and post meta-information about their bookmarks and index lists to...
متن کامل